home *** CD-ROM | disk | FTP | other *** search
/ Programming Microsoft Visual Basic .NET / Programming Microsoft Visual Basic .NET (Microsoft Press)(X08-78517)(2002).bin / 21 adonet disconnected / adonetdisconnected / pubs.xsd < prev    next >
Extensible Markup Language  |  2001-12-03  |  2KB  |  44 lines
  1. <?xml version="1.0" standalone="yes"?>
  2. <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
  3.   <xs:element name="NewDataSet" msdata:IsDataSet="true">
  4.     <xs:complexType>
  5.       <xs:choice maxOccurs="unbounded">
  6.         <xs:element name="Publishers">
  7.           <xs:complexType>
  8.             <xs:sequence>
  9.               <xs:element name="pub_id" type="xs:string" minOccurs="0" />
  10.               <xs:element name="pub_name" type="xs:string" minOccurs="0" />
  11.               <xs:element name="city" type="xs:string" minOccurs="0" />
  12.               <xs:element name="state" type="xs:string" minOccurs="0" />
  13.               <xs:element name="country" type="xs:string" minOccurs="0" />
  14.             </xs:sequence>
  15.           </xs:complexType>
  16.         </xs:element>
  17.         <xs:element name="Titles">
  18.           <xs:complexType>
  19.             <xs:sequence>
  20.               <xs:element name="title_id" type="xs:string" minOccurs="0" />
  21.               <xs:element name="title" type="xs:string" minOccurs="0" />
  22.               <xs:element name="type" type="xs:string" minOccurs="0" />
  23.               <xs:element name="pub_id" type="xs:string" minOccurs="0" />
  24.               <xs:element name="price" type="xs:decimal" minOccurs="0" />
  25.               <xs:element name="advance" type="xs:decimal" minOccurs="0" />
  26.               <xs:element name="royalty" type="xs:int" minOccurs="0" />
  27.               <xs:element name="ytd_sales" type="xs:int" minOccurs="0" />
  28.               <xs:element name="notes" type="xs:string" minOccurs="0" />
  29.               <xs:element name="pubdate" type="xs:dateTime" minOccurs="0" />
  30.             </xs:sequence>
  31.           </xs:complexType>
  32.         </xs:element>
  33.       </xs:choice>
  34.     </xs:complexType>
  35.     <xs:unique name="Constraint1">
  36.       <xs:selector xpath=".//Publishers" />
  37.       <xs:field xpath="pub_id" />
  38.     </xs:unique>
  39.     <xs:keyref name="PubTitles" refer="Constraint1">
  40.       <xs:selector xpath=".//Titles" />
  41.       <xs:field xpath="pub_id" />
  42.     </xs:keyref>
  43.   </xs:element>
  44. </xs:schema>